﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of eComDeliveryProvider">
	<Sql>
		SELECT
			dp.id, dp.name, dp.bizObjType
		FROM
			eComDeliveryProviders as dp
			INNER JOIN eComCompanyDeliveryProviders as cp on dp.id = cp.shippingProviderId
		WHERE
			cp.companyId = @companyId
	</Sql>
	<Param name="companyId" type="UniqueIdentifier"/>
</AdoNetDataAccess>